instantOLAP 3.0 update 1

The first service release for the version 3 is available on our download page. The update contains a number of bugfixes and compability enhancements for reports from older versions. Continue reading for a complete list of all changes.

Release notes

Web-Frontend

• Selectors now lose their selection if their options change and the old selection is not part of the new options
• Better start zoom for Geo Charts (the charts fills the block 100% now) andmore data types for shape DBF files supported
• Hierarchy selectors now also support hierarchies with missing levels (in example if the user has no access to a whole level)
• The new reset button for queries resets all selectors to their default selection
• Better IE support for tables with fixed headers
• Better performance for the model tree in the query editor with large models
• Dimensions are now displayed with their caption in the query editor
• Scrollbars added for selectors wider than the Browser window
• The automation editor in the Browser now allows to edit the iteration
• The visible property for selectors and selector groups is now supported
• Wider color editor (the toolbar wasn’t completely visible in all Browsers)
• The report title is now optionally visible in Fit-To-Screen mode (use the new property „Show Property“)
• Table block with ONLY width or height now also become scrollable tables
• The block title now fits to the font size
• Icon paths for folders and reports can be relative now
• The new „Search from Start“ property for SuggestBoxes allows to search for Items beginning (instead of containing) the text
• The __hidePortal parameter is now only valid for a single window instead for the whole session
• The new property „fontFolder“ allows to locate the font folder for PDF export  if the system is unable to locate it automatically
• Bugfix: SuggestBoxes inside a popup selector group have been displayed behind the group
• Bugfix: The needSelection property now works with input fields
• Bugfix: The permalinks are now selectable in Chrome and Safari
• Bugfix: A font size in comments caused an IOException when exporting to Excel
• Bugfix: Rotated headers fixed
• Bugfix: The query converter for reports from older versions now also converts tables with multiple sub-queries
• Bugfix: Default selection for Interval Selectors is now displayed
• Bugfix: A deadlock situation opened too many threads and caused memory problems
• Bugfix: Better cleanup for temporary files
• Bugfix: FileUpload now works with Chrome and Safari Browsers

Server

• SQL Expression can be used in Table Links now
• Cache size and compression level for dimension and store files are now configurable with properties
• Better performance for file caches
• Values without a mapping are mapped to the root key when loaded into a Store. This makes totals equal to the values queried from an adhoc cube.
• Better read performance for Stores
• New Function YTDR (equal to YTD but with support for large filters with multiple keys)
• The FORECAST function now returns NULL values instead of NaN for unpredictable cells
• The engine is now fully compatible with reports from version 2.2 – 2.6 (By default, ToDo lists are generated cell wise)
• Improved access control (if the root key is read protected, all headers with the key will be removed even if they do not iterate over the protected dimension)
• Bugfix: Filter for Blocks and Reports fixed
• Bugfix: Match for multiple Stores for the same adhoc cube fixed
• Bugfix: Selectors with name and key options now select the id of the keys (was <dimension>:'<id>‘ before)